In business, it is important that the data stored by an organisation is accessed, manipulated and analysed in a secure and robust manner. Integration with other applications and sharing data between users is now commonplace, making security an essential consideration in spreadsheet design.
Course Objectives:
• Learners will be able to use nested IF Functions
• Learners will be able to use both Absolute and Relative cell referencing in spreadsheet formulas.
• Learners will be able to set up a date and time functions, trimming, concatenate,
• Learners will be able to use Excel VLOOKUP and HLOOKUP tables in order to build a single formula to produce multiple results which operate on a group of arguments arranged in columns or rows.
• Learners will be able to present specific Data using Excel tools: Pivot Tables, Charts, and Analyse Data with ‘What if’ Tools.

Book Now for this Training